﻿CREATE TABLE [dbo].[t_BQ_NewBatch] (
    [Customer #]             FLOAT          NULL,
    [Last Name]              NVARCHAR (255) NULL,
    [First Name]             NVARCHAR (255) NULL,
    [Full Name]              NVARCHAR (255) NULL,
    [Address]                NVARCHAR (255) NULL,
    [City]                   NVARCHAR (255) NULL,
    [St]                     NVARCHAR (255) NULL,
    [Zip Code]               NVARCHAR (255) NULL,
    [Home Phone #]           NVARCHAR (255) NULL,
    [Work Phone #]           NVARCHAR (255) NULL,
    [Car Year]               FLOAT          NULL,
    [Make]                   NVARCHAR (255) NULL,
    [Model]                  NVARCHAR (255) NULL,
    [Serial#]                NVARCHAR (255) NULL,
    [Pmt Freq]               NVARCHAR (255) NULL,
    [# Pmts Md]              FLOAT          NULL,
    [Total $ Paid]           NVARCHAR (255) NULL,
    [Open Date]              DATETIME       NULL,
    [Maturity Date]          DATETIME       NULL,
    [Pymnt Schedule]         NVARCHAR (255) NULL,
    [# of Payments]          FLOAT          NULL,
    [Payment Amount]         MONEY          NULL,
    [Total Payments]         NVARCHAR (255) NULL,
    [1st# Payment Date]      DATETIME       NULL,
    [Last Payment Date]      DATETIME       NULL,
    [Next Payment Date]      DATETIME       NULL,
    [# Pmts Remaining]       FLOAT          NULL,
    [Balance Remaining]      MONEY          NULL,
    [Total Sales Price]      NVARCHAR (255) NULL,
    [Finance Charges]        NVARCHAR (255) NULL,
    [Purchase Price]         NVARCHAR (255) NULL,
    [Other Chgs Balance]     NVARCHAR (255) NULL,
    [P#O#E#]                 NVARCHAR (255) NULL,
    [Loan#/Comments]         NVARCHAR (255) NULL,
    [Primary SSN]            NVARCHAR (255) NULL,
    [Amt Financed]           MONEY          NULL,
    [Principal Balance]      MONEY          NULL,
    [Interest Accrued]       FLOAT          NULL,
    [APR]                    NVARCHAR (255) NULL,
    [Mileage]                NVARCHAR (255) NULL,
    [Recourse Y/N?]          NVARCHAR (255) NULL,
    [Black Book Value (Avg)] FLOAT          NULL,
    [Down Payment]           MONEY          NULL,
    [Joint Name]             NVARCHAR (255) NULL,
    [Joint Address]          NVARCHAR (255) NULL,
    [Joint City]             NVARCHAR (255) NULL,
    [Joint State]            NVARCHAR (255) NULL,
    [Joint Zipcode]          NVARCHAR (255) NULL,
    [Joint SSN]              NVARCHAR (255) NULL,
    [Joint H Phone#]         NVARCHAR (255) NULL,
    [Joint W Phone#]         NVARCHAR (255) NULL,
    [Primary Cell #]         NVARCHAR (255) NULL
);

